Film_Locations_in_San_Francisco

Data source: data.sfgov.org

19 rows where Production Company = 104

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Title, Release Year, Director, Writer, Actor 1, Actor 2

Link rowid ▼ Title Release Year Locations Fun Facts Production Company Distributor Director Writer Actor 1 Actor 2 Actor 3
885 885 Metro 164 1997 8 Bush Street at Jones   Touchstone Pictures 104 Buena Vista Pictures 25 Thomas Carter 140 Randy Feldman 143 Eddie Murphy 3    
1022 1022 Phenomenon 190 1996 43 Treasure Island An artificial island, Treasure Island was created for the 1939 Golden Gate International Exposition, and is named after the novel by Robert Louis Stevenson, a one-time San Francisco resident. Touchstone Pictures 104 Buena Vista Pictures 25 Jon Turteltaub 159 Gerald Dipego 164 John Travolta 359 Kyra Sedgwick 146  
1034 1034 Pretty Woman 195 1990 17     Touchstone Pictures 104 Buena Vista Pictures 25 Garry Marshall 27 J.F. Lawton 168 Richard Gere 264 Julia Roberts 150  
1165 1165 Sister Act 218 1992 22 St. Paul's Church (Church Street, Noe Valley)   Touchstone Pictures 104 Buena Vista Pictures 25 Emile Ardolino 180 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1166 1166 Sister Act 2: Back in the Habit 219 1993 46 St. Peter & Paul's Church (666 Filbert Street, Washington Square) Though Marilyn Monroe and Joe DiMaggio were not allowed to be married at the Church (DiMaggio had married his first wife at the Church but was divorced), the couple returned to the steps of the Church for photos, following their City Hall nuptials. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1167 1167 Sister Act 2: Back in the Habit 219 1993 46 Maritime Museum, Building 201 (Fort Mason)   Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1168 1168 Sister Act 2: Back in the Habit 219 1993 46 Coit Tower The Tower was funded by a gift bequeathed by Lillie Hitchcock Coit, a socialite who reportedly liked to chase fires. Though the tower resembles a firehose nozzle, it was not designed this way. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1169 1169 Sister Act 2: Back in the Habit 219 1993 46 CCSF Alemany Campus   Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1170 1170 Sister Act 2: Back in the Habit 219 1993 46 Carnelian Room, Bank of America Building (555 California Street, 53rd Floor) The Bank of America Building was the tallest building on the West Coast from 1969-1972, when it was surpassed by the TransAmerica Pyramid. Today, the Bank of America building is the 5th tallest building on the West Coast. Touchstone Pictures 104 Buena Vista Pictures 25 Bill Duke 181 Joseph Howard 190 Whoopi Goldberg 274 Maggie Smith 167  
1450 1450 The Nightmare Before Christmas 271 1993 46     Touchstone Pictures 104 Buena Vista Pictures 25 Henry Selick 129 Tim Burton 234 Danny Elfman 412 Catherine O'Hara 208  
1557 1557 Under the Tuscan Sun 295 2003 38 Mecca Restaurant (2029 Market Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Audrey Wells 240 Audrey Wells 255 Diane Lane 112 Sandra Oh 229  
1590 1590 When a Man Loves a Woman 302 1994 48 Buena Vista Café (2765 Hyde Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1591 1591 When a Man Loves a Woman 302 1994 48 Victor's Restaurant, The Westin St. Francis Hotel (335 Powell Street) The hotel was originally supposed to be named the Crocker Hotel, after Charles Founder the railroad magnate who founded it. However, the hotel took the name the St. Francis after one of the earliest Gold Rush hotels. Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1592 1592 When a Man Loves a Woman 302 1994 48 Spring Valley School (1451 Jackson Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1593 1593 When a Man Loves a Woman 302 1994 48 International Studies Academy (993 Vermont Street, Potrero Hill)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1594 1594 When a Man Loves a Woman 302 1994 48 Grant Street at Pacific Avenue   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1595 1595 When a Man Loves a Woman 302 1994 48 Cybelle's Pizza (1000 Bush Street)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1596 1596 When a Man Loves a Woman 302 1994 48 766 Vallejo Street at Stockton Street (North Beach)   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  
1597 1597 When a Man Loves a Woman 302 1994 48 1521 Masonic Avenue at Piedmont Street   Touchstone Pictures 104 Buena Vista Pictures 25 Luis Mandoki 246 Ronald Bass 262 Andy Garcia 58 Meg Ryan 46  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "Film_Locations_in_San_Francisco" (
"Title" INTEGER,
  "Release Year" INTEGER,
  "Locations" TEXT,
  "Fun Facts" REAL,
  "Production Company" INTEGER,
  "Distributor" INTEGER,
  "Director" INTEGER,
  "Writer" INTEGER,
  "Actor 1" INTEGER,
  "Actor 2" INTEGER,
  "Actor 3" INTEGER
,
FOREIGN KEY ("Title") REFERENCES [Title](id),
    FOREIGN KEY ("Director") REFERENCES [Director](id),
    FOREIGN KEY ("Actor 2") REFERENCES [Actors](id),
    FOREIGN KEY ("Actor 1") REFERENCES [Actors](id),
    FOREIGN KEY ("Writer") REFERENCES [Writer](id),
    FOREIGN KEY ("Release Year") REFERENCES [Release Year](id),
    FOREIGN KEY ("Actor 3") REFERENCES [Actors](id),
    FOREIGN KEY ("Production Company") REFERENCES [Production Company](id),
    FOREIGN KEY ("Distributor") REFERENCES [Distributor](id));
CREATE INDEX ["Film_Locations_in_San_Francisco_Title"] ON [Film_Locations_in_San_Francisco]("Title");
CREATE INDEX ["Film_Locations_in_San_Francisco_Director"] ON [Film_Locations_in_San_Francisco]("Director");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 2"] ON [Film_Locations_in_San_Francisco]("Actor 2");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 1"] ON [Film_Locations_in_San_Francisco]("Actor 1");
CREATE INDEX ["Film_Locations_in_San_Francisco_Writer"] ON [Film_Locations_in_San_Francisco]("Writer");
CREATE INDEX ["Film_Locations_in_San_Francisco_Release Year"] ON [Film_Locations_in_San_Francisco]("Release Year");
CREATE INDEX ["Film_Locations_in_San_Francisco_Actor 3"] ON [Film_Locations_in_San_Francisco]("Actor 3");
CREATE INDEX ["Film_Locations_in_San_Francisco_Production Company"] ON [Film_Locations_in_San_Francisco]("Production Company");
CREATE INDEX ["Film_Locations_in_San_Francisco_Distributor"] ON [Film_Locations_in_San_Francisco]("Distributor");
Powered by Datasette · Query took 37.029ms · Data source: data.sfgov.org